Skip to main content
Version: 5.1.0.0

MSSQL

Configuration Adjustments​

The needed SQL scripts for the database creation can be found in ...\database_scripts\scripts\MSSQLServer_Other\system

Steps​

  1. Start Microsoft SQL Server Management Studio.

  2. Log in as user SA.

  3. Open V01__sys_create_database.sql.

  4. Change the paths to your local system.

    warning

    The password of the SOLUTIONHUB database user should be changed for security reasons!

  5. Run the script.

  6. Close the database connection.

  7. Set up the database by following the steps described in Flyway database setup.

danger

If the login as user SOLUTIONHUB does not work (even though the user exists), this may be due to SQL Server not being configured for SQL authentication.

Configure Microsoft SQL Server for Mixed Mode Authentication (2005/2008/2012)​

SQL Server uses a two-phase authentication scheme:

  • Windows Authentication Mode
  • Mixed Mode (Windows + SQL Authentication)

To enable Mixed Mode:

  1. Open Microsoft SQL Server Management Studio.
  2. Click Start → Programs → Microsoft SQL Server, and select the correct version.
  3. Enter server details and connect.
  4. Right-click your server name → Properties.
  5. Go to the Security tab.
  6. Under Server authentication, select SQL Server and Windows Authentication Mode.
  7. Click OK.
  8. Right-click the server again → Restart.
  • If login still fails, ensure the user has permission to connect to the database engine.

Configuring Snapshot Settings in SQL Server​

Using SQL Query​

  1. Open SQL Server Management Studio.

  2. Connect to the Database Engine.

  3. Click New Query.

  4. Paste and execute:

ALTER DATABASE CURRENT SET ALLOW_SNAPSHOT_ISOLATION ON;
GO
ALTER DATABASE CURRENT SET READ_COMMITTED_SNAPSHOT ON WITH NO_WAIT;
GO

Manually via Management Studio​

  1. Open SQL Server Management Studio.

  2. Connect to the database engine via Object Explorer.

  3. Right-click your database → Properties.

  4. Go to the Options page.

  5. Set Allow Snapshot Isolation and Is Read Committed Snapshot On to True.

  6. Click OK to save changes.

Check TCP/IP Settings of SQL Server​

  1. Start SQL Server Configuration Manager (part of SQL Server installation).

  2. Select SQL Server Network Configuration in the left pane.

  3. Check if TCP/IP is enabled in the right pane.

    • If not enabled, right-click TCP/IP and choose Enable.

  4. The default TCP/IP port used by SQL Server is 1433.